****** 예약어 ****** 아래는 CUBRID 키워드(keywords) 중 명령어, 함수명, 타입명 등으로 예약되어 있는 예약어(reserved words)를 정리한 표이다. 사용자는 테이블 이름, 칼럼 이름, 변수 이름과 같은 식별자(identifier)로 아래에 정리된 예약어를 사용할 수 없다. 단, 큰따옴표(" ")나 대괄호([ ]) 또는 백틱 부호(\` \`)로 감싸는 방법으로 예약어를 식별자로 사용할 수 있다. +----------------------+----------------------+----------------------+ | ABSOLUTE | ACTION | ADD | +----------------------+----------------------+----------------------+ | ADD_MONTHS | AFTER | ALL | +----------------------+----------------------+----------------------+ | ALLOCATE | ALTER | AND | +----------------------+----------------------+----------------------+ | ANY | ARE | AS | +----------------------+----------------------+----------------------+ | ASC | ASSERTION | AT | +----------------------+----------------------+----------------------+ | ATTACH | ATTRIBUTE | AVG | +----------------------+----------------------+----------------------+ | BEFORE | BETWEEN | BIGINT | +----------------------+----------------------+----------------------+ | BIT | BIT_LENGTH | BLOB | +----------------------+----------------------+----------------------+ | BOOLEAN | BOTH | BREADTH | +----------------------+----------------------+----------------------+ | BY | | | +----------------------+----------------------+----------------------+ | CALL | CASCADE | CASCADED | +----------------------+----------------------+----------------------+ | CASE | CAST | CATALOG | +----------------------+----------------------+----------------------+ | CHANGE | CHAR | CHARACTER | +----------------------+----------------------+----------------------+ | CHECK | CLASS | CLASSES | +----------------------+----------------------+----------------------+ | CLOB | CLOSE | COALESCE | +----------------------+----------------------+----------------------+ | COLUMN | COMMIT | CONNECT | +----------------------+----------------------+----------------------+ | CONNECT_BY_ISCYCLE | CONNECT_BY_ISLEAF | CONNECT_BY_ROOT | +----------------------+----------------------+----------------------+ | CONNECTION | CONSTRAINT | CONSTRAINTS | +----------------------+----------------------+----------------------+ | CONTINUE | CONVERT | CORRESPONDING | +----------------------+----------------------+----------------------+ | COUNT | CREATE | CROSS | +----------------------+----------------------+----------------------+ | CURRENT | CURRENT_DATE | CURRENT_DATETIME | +----------------------+----------------------+----------------------+ | CURRENT_TIME | CURRENT_TIMESTAMP | CURRENT_USER | +----------------------+----------------------+----------------------+ | CURSOR | CYCLE | | +----------------------+----------------------+----------------------+ | DATA | DATA_TYPE | DATABASE | +----------------------+----------------------+----------------------+ | DATE | DATETIME | DAY | +----------------------+----------------------+----------------------+ | DAY_HOUR | DAY_MILLISECOND | DAY_MINUTE | +----------------------+----------------------+----------------------+ | DAY_SECOND | DEALLOCATE | DEC | +----------------------+----------------------+----------------------+ | DECIMAL | DECLARE | DEFAULT | +----------------------+----------------------+----------------------+ | DEFERRABLE | DEFERRED | DELETE | +----------------------+----------------------+----------------------+ | DEPTH | DESC | DESCRIBE | +----------------------+----------------------+----------------------+ | DESCRIPTOR | DIAGNOSTICS | DIFFERENCE | +----------------------+----------------------+----------------------+ | DISCONNECT | DISTINCT | DISTINCTROW | +----------------------+----------------------+----------------------+ | DIV | DO | DOMAIN | +----------------------+----------------------+----------------------+ | DOUBLE | DUPLICATE | DROP | +----------------------+----------------------+----------------------+ | EACH | ELSE | ELSEIF | +----------------------+----------------------+----------------------+ | END | EQUALS | ESCAPE | +----------------------+----------------------+----------------------+ | EVALUATE | EXCEPT | EXCEPTION | +----------------------+----------------------+----------------------+ | EXEC | EXECUTE | EXISTS | +----------------------+----------------------+----------------------+ | EXTERNAL | EXTRACT | | +----------------------+----------------------+----------------------+ | FALSE | FETCH | FILE | +----------------------+----------------------+----------------------+ | FIRST | FLOAT | FOR | +----------------------+----------------------+----------------------+ | FOREIGN | FOUND | FROM | +----------------------+----------------------+----------------------+ | FULL | FUNCTION | | +----------------------+----------------------+----------------------+ | GENERAL | GET | GLOBAL | +----------------------+----------------------+----------------------+ | GO | GOTO | GRANT | +----------------------+----------------------+----------------------+ | GROUP | | | +----------------------+----------------------+----------------------+ | HAVING | HOUR | HOUR_MILLISECOND | +----------------------+----------------------+----------------------+ | HOUR_MINUTE | HOUR_SECOND | | +----------------------+----------------------+----------------------+ | IDENTITY | IF | IGNORE | +----------------------+----------------------+----------------------+ | IMMEDIATE | IN | INDEX | +----------------------+----------------------+----------------------+ | INDICATOR | INHERIT | INITIALLY | +----------------------+----------------------+----------------------+ | INNER | INOUT | INPUT | +----------------------+----------------------+----------------------+ | INSERT | INT | INTEGER | +----------------------+----------------------+----------------------+ | INTERSECT | INTERSECTION | INTERVAL | +----------------------+----------------------+----------------------+ | INTO | IS | ISOLATION | +----------------------+----------------------+----------------------+ | JOIN | | | +----------------------+----------------------+----------------------+ | KEY | | | +----------------------+----------------------+----------------------+ | LANGUAGE | LAST | LEADING | +----------------------+----------------------+----------------------+ | LEAVE | LEFT | LESS | +----------------------+----------------------+----------------------+ | LEVEL | LIKE | LIMIT | +----------------------+----------------------+----------------------+ | LIST | LOCAL | LOCAL_TRANSACTION_ID | +----------------------+----------------------+----------------------+ | LOCALTIME | LOCALTIMESTAMP | LOOP | +----------------------+----------------------+----------------------+ | LOWER | | | +----------------------+----------------------+----------------------+ | MATCH | MAX | METHOD | +----------------------+----------------------+----------------------+ | MILLISECOND | MIN | MINUTE | +----------------------+----------------------+----------------------+ | MINUTE_MILLISECOND | MINUTE_SECOND | MOD | +----------------------+----------------------+----------------------+ | MODIFY | MODULE | MONTH | +----------------------+----------------------+----------------------+ | MULTISET | MULTISET_OF | | +----------------------+----------------------+----------------------+ | NA | NAMES | NATIONAL | +----------------------+----------------------+----------------------+ | NATURAL | NCHAR | NEXT | +----------------------+----------------------+----------------------+ | NO | NONE | NOT | +----------------------+----------------------+----------------------+ | NULL | NULLIF | NUMERIC | +----------------------+----------------------+----------------------+ | OBJECT | OCTET_LENGTH | OF | +----------------------+----------------------+----------------------+ | OFF | ON | ONLY | +----------------------+----------------------+----------------------+ | OPEN | OPTIMIZATION | OPTION | +----------------------+----------------------+----------------------+ | OR | ORDER | OUT | +----------------------+----------------------+----------------------+ | OUTER | OUTPUT | OVERLAPS | +----------------------+----------------------+----------------------+ | PARAMETERS | PARTIAL | POSITION | +----------------------+----------------------+----------------------+ | PRECISION | PREPARE | PRESERVE | +----------------------+----------------------+----------------------+ | PRIMARY | PRIOR | PRIVILEGES | +----------------------+----------------------+----------------------+ | PROCEDURE | | | +----------------------+----------------------+----------------------+ | QUERY | | | +----------------------+----------------------+----------------------+ | READ | REAL | RECURSIVE | +----------------------+----------------------+----------------------+ | REF | REFERENCES | REFERENCING | +----------------------+----------------------+----------------------+ | RELATIVE | RENAME | REPLACE | +----------------------+----------------------+----------------------+ | RESIGNAL | RESTRICT | RETURN | +----------------------+----------------------+----------------------+ | RETURNS | REVOKE | RIGHT | +----------------------+----------------------+----------------------+ | ROLE | ROLLBACK | ROLLUP | +----------------------+----------------------+----------------------+ | ROUTINE | ROW | ROWNUM | +----------------------+----------------------+----------------------+ | ROWS | | | +----------------------+----------------------+----------------------+ | SAVEPOINT | SCHEMA | SCOPE | +----------------------+----------------------+----------------------+ | SCROLL | SEARCH | SECOND | +----------------------+----------------------+----------------------+ | SECOND_MILLISECOND | SECTION | SELECT | +----------------------+----------------------+----------------------+ | SENSITIVE | SEQUENCE | SEQUENCE_OF | +----------------------+----------------------+----------------------+ | SERIALIZABLE | SESSION | SESSION_USER | +----------------------+----------------------+----------------------+ | SET | SET_OF | SETEQ | +----------------------+----------------------+----------------------+ | SHARED | SIBLINGS | SIGNAL | +----------------------+----------------------+----------------------+ | SIMILAR | SIZE | SMALLINT | +----------------------+----------------------+----------------------+ | SOME | SQL | SQLCODE | +----------------------+----------------------+----------------------+ | SQLERROR | SQLEXCEPTION | SQLSTATE | +----------------------+----------------------+----------------------+ | SQLWARNING | STATISTICS | STRING | +----------------------+----------------------+----------------------+ | SUBCLASS | SUBSET | SUBSETEQ | +----------------------+----------------------+----------------------+ | SUBSTRING | SUM | SUPERCLASS | +----------------------+----------------------+----------------------+ | SUPERSET | SUPERSETEQ | SYS_CONNECT_BY_PATH | +----------------------+----------------------+----------------------+ | SYS_DATE | SYS_DATETIME | SYS_TIME | +----------------------+----------------------+----------------------+ | SYS_TIMESTAMP | SYSDATE | SYSDATETIME | +----------------------+----------------------+----------------------+ | SYSTEM_USER | SYSTIME | | +----------------------+----------------------+----------------------+ | TABLE | TEMPORARY | THEN | +----------------------+----------------------+----------------------+ | TIME | TIMESTAMP | TIMEZONE_HOUR | +----------------------+----------------------+----------------------+ | TIMEZONE_MINUTE | TO | TRAILING | +----------------------+----------------------+----------------------+ | TRANSACTION | TRANSLATE | TRANSLATION | +----------------------+----------------------+----------------------+ | TRIGGER | TRIM | TRUE | +----------------------+----------------------+----------------------+ | TRUNCATE | | | +----------------------+----------------------+----------------------+ | UNDER | UNION | UNIQUE | +----------------------+----------------------+----------------------+ | UNKNOWN | UPDATE | UPPER | +----------------------+----------------------+----------------------+ | USAGE | USE | USER | +----------------------+----------------------+----------------------+ | USING | UTIME | | +----------------------+----------------------+----------------------+ | VALUE | VALUES | VARCHAR | +----------------------+----------------------+----------------------+ | VARIABLE | VARYING | VCLASS | +----------------------+----------------------+----------------------+ | VIEW | | | +----------------------+----------------------+----------------------+ | WHEN | WHENEVER | WHERE | +----------------------+----------------------+----------------------+ | WHILE | WITH | WITHOUT | +----------------------+----------------------+----------------------+ | WORK | WRITE | | +----------------------+----------------------+----------------------+ | XOR | | | +----------------------+----------------------+----------------------+ | YEAR | YEAR_MONTH | | +----------------------+----------------------+----------------------+ | ZONE | | | +----------------------+----------------------+----------------------+